$sql = "SELECT * FROM post WHERE id='".$_GET['idpost']."'";
$exec = mysql_query($sql,$conn)
or die("Errore: ".mysql_error());
$ris = mysql_fetch_array($exec);
$data = explode("-", $ris['data']);
$mese = $data[1];
$giorno = $data[2];
include("include/time.inc");
?>
print $m; ?>
print $giorno; ?>
print $ris['testo']; ?>
$sqlcm2 = "SELECT * FROM commenti WHERE id_post='".$ris['id']."' and online='S' ORDER BY data, id";
$execcm2 = mysql_query($sqlcm2,$conn)
or die("Errore: ".mysql_error());
while ($riscm2 = mysql_fetch_array($execcm2)) {
$dtcm = explode("-", $riscm2['data']);
$datacm = $dtcm[2]."-".$dtcm[1]."-".$dtcm[0];
?>
Data: print $datacm; ?>
print $riscm2['commento']; ?>
Autore: print $riscm2['autore']; ?>
}?>
$sqlcat = "SELECT * FROM categorie WHERE id='".$ris['categoria']."'"; $execcat = mysql_query($sqlcat,$conn) or die("Errore: ".mysql_error()); $riscat = mysql_fetch_array($execcat); ?> print $riscat['categoria']; ?> | $sqlcm = "SELECT * FROM commenti WHERE id_post='".$ris['id']."' and online='S' ORDER BY id"; $execcm = mysql_query($sqlcm,$conn) or die("Errore: ".mysql_error()); $numcm = mysql_numrows($execcm); if ($numcm>0) { if ($numcm==1) {?> 1 commento | } else {?> print $numcm; ?> commenti | } } else {?> Nessun commento | }?> Commenta